Overview

Brought to you by YData

Dataset statistics

Number of variables	23
Number of observations	555719
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	97.5 MiB
Average record size in memory	184.0 B

Variable types

Numeric	10
DateTime	2
Text	7
Categorical	4

Alerts

`Unnamed: 0` is highly overall correlated with `unix_time`	High correlation
`lat` is highly overall correlated with `merch_lat` and 1 other fields	High correlation
`long` is highly overall correlated with `merch_long` and 2 other fields	High correlation
`merch_lat` is highly overall correlated with `lat` and 1 other fields	High correlation
`merch_long` is highly overall correlated with `long` and 2 other fields	High correlation
`state` is highly overall correlated with `lat` and 4 other fields	High correlation
`unix_time` is highly overall correlated with `Unnamed: 0`	High correlation
`zip` is highly overall correlated with `long` and 2 other fields	High correlation
`is_fraud` is highly imbalanced (96.3%)	Imbalance
`amt` is highly skewed (γ1 = 37.13407684)	Skewed
`Unnamed: 0` is uniformly distributed	Uniform
`Unnamed: 0` has unique values	Unique
`trans_num` has unique values	Unique

Reproduction

Analysis started	2025-10-04 13:02:16.538574
Analysis finished	2025-10-04 13:03:11.372414
Duration	54.83 seconds
Software version	ydata-profiling vv4.17.0
Download configuration	config.json

Unnamed: 0
Real number (ℝ)

High correlation Uniform Unique

Distinct	555719
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	277859

Minimum	0
Maximum	555718
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	0
5-th percentile	27785.9
Q1	138929.5
median	277859
Q3	416788.5
95-th percentile	527932.1
Maximum	555718
Range	555718
Interquartile range (IQR)	277859

Descriptive statistics

Standard deviation	160422.4
Coefficient of variation (CV)	0.57735183
Kurtosis	-1.2
Mean	277859
Median Absolute Deviation (MAD)	138930
Skewness	-1.206865 × 10^-15
Sum	1.5441153 × 10¹¹
Variance	2.5735347 × 10¹⁰
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
555718	1	< 0.1%
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
555702	1	< 0.1%
555701	1	< 0.1%
555700	1	< 0.1%
Other values (555709)	555709	> 99.9%

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
555718	1	< 0.1%
555717	1	< 0.1%
555716	1	< 0.1%
555715	1	< 0.1%
555714	1	< 0.1%
555713	1	< 0.1%
555712	1	< 0.1%
555711	1	< 0.1%
555710	1	< 0.1%
555709	1	< 0.1%

trans_date_trans_time
Date

Distinct	544760
Distinct (%)	98.0%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

Minimum	2020-06-21 12:14:25
Maximum	2020-12-31 23:59:34
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

cc_num
Real number (ℝ)

Distinct	924
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.178387 × 10¹⁷

Minimum	6.0416207 × 10¹⁰
Maximum	4.9923464 × 10¹⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	6.0416207 × 10¹⁰
5-th percentile	6.3048488 × 10¹¹
Q1	1.8004295 × 10¹⁴
median	3.5214173 × 10¹⁵
Q3	4.6353306 × 10¹⁵
95-th percentile	4.497914 × 10¹⁸
Maximum	4.9923464 × 10¹⁸
Range	4.9923463 × 10¹⁸
Interquartile range (IQR)	4.4552876 × 10¹⁵

Descriptive statistics

Standard deviation	1.3098366 × 10¹⁸
Coefficient of variation (CV)	3.1347901
Kurtosis	6.1647169
Mean	4.178387 × 10¹⁷
Median Absolute Deviation (MAD)	3.0764709 × 10¹⁵
Skewness	2.8492038
Sum	-6.7123593 × 10¹⁸
Variance	1.715672 × 10³⁶
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6.538441737 × 10¹⁵	1474	0.3%
4.586810169 × 10¹⁵	1466	0.3%
4.745996322 × 10¹²	1462	0.3%
4.587657402 × 10¹⁸	1458	0.3%
2.242542703 × 10¹⁵	1428	0.3%
3.02730377 × 10¹³	1426	0.3%
3.725200498 × 10¹⁴	1403	0.3%
3.02704321 × 10¹³	1386	0.2%
4.364010865 × 10¹⁵	1375	0.2%
3.447098678 × 10¹⁴	1358	0.2%
Other values (914)	541483	97.4%

Value	Count	Frequency (%)
6.041620718 × 10¹⁰	678	0.1%
6.042292873 × 10¹⁰	669	0.1%
6.042309813 × 10¹⁰	228	< 0.1%
6.042785159 × 10¹⁰	215	< 0.1%
6.048700208 × 10¹⁰	239	< 0.1%
6.04905963 × 10¹⁰	455	0.1%
6.049559311 × 10¹⁰	224	< 0.1%
5.018029536 × 10¹¹	635	0.1%
5.018282048 × 10¹¹	218	< 0.1%
5.018310822 × 10¹¹	439	0.1%

Value	Count	Frequency (%)
4.992346398 × 10¹⁸	863	0.2%
4.989847571 × 10¹⁸	464	0.1%
4.980323468 × 10¹⁸	204	< 0.1%
4.973530368 × 10¹⁸	427	0.1%
4.958589672 × 10¹⁸	715	0.1%
4.95682899 × 10¹⁸	1091	0.2%
4.906628656 × 10¹⁸	1071	0.2%
4.897067971 × 10¹⁸	433	0.1%
4.890424427 × 10¹⁸	693	0.1%
4.861310131 × 10¹⁸	1119	0.2%

merchant
Text

Distinct	693
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

Length

Max length	43
Median length	36
Mean length	23.125785
Min length	13

Characters and Unicode

Total characters	12851438
Distinct characters	55
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	fraud_Kirlin and Sons
2nd row	fraud_Sporer-Keebler
3rd row	fraud_Swaniawski, Nitzsche and Welch
4th row	fraud_Haley Group
5th row	fraud_Johnston-Casper

Value	Count	Frequency (%)
and	203251	15.7%
llc	41882	3.2%
inc	39209	3.0%
sons	31506	2.4%
ltd	30043	2.3%
plc	28324	2.2%
group	21642	1.7%
fraud_kutch	4468	0.3%
fraud_streich	3985	0.3%
fraud_schaefer	3973	0.3%
Other values (804)	886783	68.5%

Most occurring characters

Value	Count	Frequency (%)
a	1247535	9.7%
r	1155590	9.0%
d	916214	7.1%
e	800035	6.2%
u	796550	6.2%
n	757549	5.9%
	739347	5.8%
f	598718	4.7%
_	555719	4.3%
o	484677	3.8%
Other values (45)	4799504	37.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	12851438	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	1247535	9.7%
r	1155590	9.0%
d	916214	7.1%
e	800035	6.2%
u	796550	6.2%
n	757549	5.9%
	739347	5.8%
f	598718	4.7%
_	555719	4.3%
o	484677	3.8%
Other values (45)	4799504	37.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	12851438	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	1247535	9.7%
r	1155590	9.0%
d	916214	7.1%
e	800035	6.2%
u	796550	6.2%
n	757549	5.9%
	739347	5.8%
f	598718	4.7%
_	555719	4.3%
o	484677	3.8%
Other values (45)	4799504	37.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	12851438	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	1247535	9.7%
r	1155590	9.0%
d	916214	7.1%
e	800035	6.2%
u	796550	6.2%
n	757549	5.9%
	739347	5.8%
f	598718	4.7%
_	555719	4.3%
o	484677	3.8%
Other values (45)	4799504	37.3%

category
Categorical

Distinct	14
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

gas_transport	56370
grocery_pos	52553
home	52345
shopping_pos	49791
kids_pets	48692
Other values (9)	295968

Length

Max length	14
Median length	12
Mean length	10.525528
Min length	4

Characters and Unicode

Total characters	5849236
Distinct characters	20
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	personal_care
2nd row	personal_care
3rd row	health_fitness
4th row	misc_pos
5th row	travel

Common Values

Value	Count	Frequency (%)
gas_transport	56370	10.1%
grocery_pos	52553	9.5%
home	52345	9.4%
shopping_pos	49791	9.0%
kids_pets	48692	8.8%
shopping_net	41779	7.5%
entertainment	40104	7.2%
personal_care	39327	7.1%
food_dining	39268	7.1%
health_fitness	36674	6.6%
Other values (4)	98816	17.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
gas_transport	56370	10.1%
grocery_pos	52553	9.5%
home	52345	9.4%
shopping_pos	49791	9.0%
kids_pets	48692	8.8%
shopping_net	41779	7.5%
entertainment	40104	7.2%
personal_care	39327	7.1%
food_dining	39268	7.1%
health_fitness	36674	6.6%
Other values (4)	98816	17.8%

Most occurring characters

Value	Count	Frequency (%)
s	613228	10.5%
e	551351	9.4%
o	527045	9.0%
n	511361	8.7%
p	464447	7.9%
t	461113	7.9%
_	445821	7.6%
r	392905	6.7%
i	357517	6.1%
a	285621	4.9%
Other values (10)	1238827	21.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	5849236	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
s	613228	10.5%
e	551351	9.4%
o	527045	9.0%
n	511361	8.7%
p	464447	7.9%
t	461113	7.9%
_	445821	7.6%
r	392905	6.7%
i	357517	6.1%
a	285621	4.9%
Other values (10)	1238827	21.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	5849236	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
s	613228	10.5%
e	551351	9.4%
o	527045	9.0%
n	511361	8.7%
p	464447	7.9%
t	461113	7.9%
_	445821	7.6%
r	392905	6.7%
i	357517	6.1%
a	285621	4.9%
Other values (10)	1238827	21.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	5849236	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
s	613228	10.5%
e	551351	9.4%
o	527045	9.0%
n	511361	8.7%
p	464447	7.9%
t	461113	7.9%
_	445821	7.6%
r	392905	6.7%
i	357517	6.1%
a	285621	4.9%
Other values (10)	1238827	21.2%

amt
Real number (ℝ)

Skewed

Distinct	37256
Distinct (%)	6.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	69.39281

Minimum	1
Maximum	22768.11
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	1
5-th percentile	2.43
Q1	9.63
median	47.29
Q3	83.01
95-th percentile	193.051
Maximum	22768.11
Range	22767.11
Interquartile range (IQR)	73.38

Descriptive statistics

Standard deviation	156.74594
Coefficient of variation (CV)	2.2588211
Kurtosis	3247.084
Mean	69.39281
Median Absolute Deviation (MAD)	37.34
Skewness	37.134077
Sum	38562903
Variance	24569.29
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.1	239	< 0.1%
1.14	237	< 0.1%
1.08	229	< 0.1%
1.31	227	< 0.1%
1.65	227	< 0.1%
1.03	227	< 0.1%
1.19	226	< 0.1%
1.07	225	< 0.1%
1.22	224	< 0.1%
1.09	224	< 0.1%
Other values (37246)	553434	99.6%

Value	Count	Frequency (%)
1	110	< 0.1%
1.01	212	< 0.1%
1.02	203	< 0.1%
1.03	227	< 0.1%
1.04	206	< 0.1%
1.05	202	< 0.1%
1.06	200	< 0.1%
1.07	225	< 0.1%
1.08	229	< 0.1%
1.09	224	< 0.1%

Value	Count	Frequency (%)
22768.11	1	< 0.1%
21437.71	1	< 0.1%
19364.91	1	< 0.1%
16837.08	1	< 0.1%
16339.26	1	< 0.1%
14637.79	1	< 0.1%
13149.15	1	< 0.1%
12969.9	1	< 0.1%
12882.78	1	< 0.1%
12882.33	1	< 0.1%

first
Text

Distinct	341
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

Length

Max length	11
Median length	9
Mean length	6.0799847
Min length	3

Characters and Unicode

Total characters	3378763
Distinct characters	49
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Jeff
2nd row	Joanne
3rd row	Ashley
4th row	Brian
5th row	Nathan

Value	Count	Frequency (%)
christopher	11443	2.1%
robert	9076	1.6%
jessica	8655	1.6%
david	8599	1.5%
michael	8530	1.5%
james	8457	1.5%
jennifer	7241	1.3%
john	7120	1.3%
mary	7078	1.3%
william	7025	1.3%
Other values (331)	472495	85.0%

Most occurring characters

Value	Count	Frequency (%)
a	430918	12.8%
e	369286	10.9%
i	265381	7.9%
n	263215	7.8%
r	260880	7.7%
l	166530	4.9%
h	148354	4.4%
s	138914	4.1%
t	133335	3.9%
o	115481	3.4%
Other values (39)	1086469	32.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3378763	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	430918	12.8%
e	369286	10.9%
i	265381	7.9%
n	263215	7.8%
r	260880	7.7%
l	166530	4.9%
h	148354	4.4%
s	138914	4.1%
t	133335	3.9%
o	115481	3.4%
Other values (39)	1086469	32.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3378763	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	430918	12.8%
e	369286	10.9%
i	265381	7.9%
n	263215	7.8%
r	260880	7.7%
l	166530	4.9%
h	148354	4.4%
s	138914	4.1%
t	133335	3.9%
o	115481	3.4%
Other values (39)	1086469	32.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3378763	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	430918	12.8%
e	369286	10.9%
i	265381	7.9%
n	263215	7.8%
r	260880	7.7%
l	166530	4.9%
h	148354	4.4%
s	138914	4.1%
t	133335	3.9%
o	115481	3.4%
Other values (39)	1086469	32.2%

last
Text

Distinct	471
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

Length

Max length	11
Median length	10
Mean length	6.1151697
Min length	2

Characters and Unicode

Total characters	3398316
Distinct characters	48
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Elliott
2nd row	Williams
3rd row	Lopez
4th row	Williams
5th row	Massey

Value	Count	Frequency (%)
smith	12146	2.2%
williams	10056	1.8%
davis	9524	1.7%
johnson	8556	1.5%
rodriguez	7485	1.3%
martinez	6441	1.2%
jones	5849	1.1%
lewis	5540	1.0%
miller	5123	0.9%
gonzalez	5010	0.9%
Other values (461)	479989	86.4%

Most occurring characters

Value	Count	Frequency (%)
e	336371	9.9%
r	282893	8.3%
a	278699	8.2%
n	260484	7.7%
o	248802	7.3%
s	209236	6.2%
l	209106	6.2%
i	187500	5.5%
t	124139	3.7%
h	98978	2.9%
Other values (38)	1162108	34.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3398316	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	336371	9.9%
r	282893	8.3%
a	278699	8.2%
n	260484	7.7%
o	248802	7.3%
s	209236	6.2%
l	209106	6.2%
i	187500	5.5%
t	124139	3.7%
h	98978	2.9%
Other values (38)	1162108	34.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3398316	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	336371	9.9%
r	282893	8.3%
a	278699	8.2%
n	260484	7.7%
o	248802	7.3%
s	209236	6.2%
l	209106	6.2%
i	187500	5.5%
t	124139	3.7%
h	98978	2.9%
Other values (38)	1162108	34.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3398316	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	336371	9.9%
r	282893	8.3%
a	278699	8.2%
n	260484	7.7%
o	248802	7.3%
s	209236	6.2%
l	209106	6.2%
i	187500	5.5%
t	124139	3.7%
h	98978	2.9%
Other values (38)	1162108	34.2%

gender
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

F	304886
M	250833

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	555719
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	M
2nd row	F
3rd row	F
4th row	M
5th row	M

Common Values

Value	Count	Frequency (%)
F	304886	54.9%
M	250833	45.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
f	304886	54.9%
m	250833	45.1%

Most occurring characters

Value	Count	Frequency (%)
F	304886	54.9%
M	250833	45.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	555719	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
F	304886	54.9%
M	250833	45.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	555719	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
F	304886	54.9%
M	250833	45.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	555719	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
F	304886	54.9%
M	250833	45.1%

street
Text

Distinct	924
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

Length

Max length	35
Median length	29
Mean length	22.236569
Min length	12

Characters and Unicode

Total characters	12357284
Distinct characters	62
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	351 Darlene Green
2nd row	3638 Marsh Union
3rd row	9333 Valentine Point
4th row	32941 Krystal Mill Apt. 552
5th row	5783 Evan Roads Apt. 465

Value	Count	Frequency (%)
apt	140506	6.4%
suite	131549	5.9%
island	9949	0.4%
michael	8091	0.4%
islands	7694	0.3%
station	7645	0.3%
common	7607	0.3%
david	7377	0.3%
brooks	7152	0.3%
fields	7079	0.3%
Other values (1845)	1876618	84.9%

Most occurring characters

Value	Count	Frequency (%)
	1655548	13.4%
e	768525	6.2%
a	622844	5.0%
i	554652	4.5%
t	534046	4.3%
r	473549	3.8%
n	457369	3.7%
s	442390	3.6%
l	381006	3.1%
o	375472	3.0%
Other values (52)	6091883	49.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	12357284	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	1655548	13.4%
e	768525	6.2%
a	622844	5.0%
i	554652	4.5%
t	534046	4.3%
r	473549	3.8%
n	457369	3.7%
s	442390	3.6%
l	381006	3.1%
o	375472	3.0%
Other values (52)	6091883	49.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	12357284	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	1655548	13.4%
e	768525	6.2%
a	622844	5.0%
i	554652	4.5%
t	534046	4.3%
r	473549	3.8%
n	457369	3.7%
s	442390	3.6%
l	381006	3.1%
o	375472	3.0%
Other values (52)	6091883	49.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	12357284	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	1655548	13.4%
e	768525	6.2%
a	622844	5.0%
i	554652	4.5%
t	534046	4.3%
r	473549	3.8%
n	457369	3.7%
s	442390	3.6%
l	381006	3.1%
o	375472	3.0%
Other values (52)	6091883	49.3%

city
Text

Distinct	849
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

Length

Max length	25
Median length	21
Mean length	8.6534957
Min length	3

Characters and Unicode

Total characters	4808912
Distinct characters	52
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Columbia
2nd row	Altonah
3rd row	Bellmore
4th row	Titusville
5th row	Falmouth

Value	Count	Frequency (%)
city	9466	1.4%
west	8374	1.2%
saint	6120	0.9%
north	6047	0.9%
falls	5492	0.8%
new	5015	0.7%
lake	4840	0.7%
mount	4723	0.7%
san	4378	0.6%
springs	3687	0.5%
Other values (876)	635691	91.6%

Most occurring characters

Value	Count	Frequency (%)
e	465724	9.7%
a	399870	8.3%
n	352121	7.3%
o	350784	7.3%
l	333877	6.9%
r	321666	6.7%
i	302768	6.3%
t	257021	5.3%
s	191281	4.0%
	138114	2.9%
Other values (42)	1695686	35.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	4808912	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	465724	9.7%
a	399870	8.3%
n	352121	7.3%
o	350784	7.3%
l	333877	6.9%
r	321666	6.7%
i	302768	6.3%
t	257021	5.3%
s	191281	4.0%
	138114	2.9%
Other values (42)	1695686	35.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	4808912	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	465724	9.7%
a	399870	8.3%
n	352121	7.3%
o	350784	7.3%
l	333877	6.9%
r	321666	6.7%
i	302768	6.3%
t	257021	5.3%
s	191281	4.0%
	138114	2.9%
Other values (42)	1695686	35.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	4808912	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	465724	9.7%
a	399870	8.3%
n	352121	7.3%
o	350784	7.3%
l	333877	6.9%
r	321666	6.7%
i	302768	6.3%
t	257021	5.3%
s	191281	4.0%
	138114	2.9%
Other values (42)	1695686	35.3%

state
Categorical

High correlation

Distinct	50
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

TX	40393
NY	35918
PA	34326
CA	24135
OH	20147
Other values (45)	400800

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	1111438
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	SC
2nd row	UT
3rd row	NY
4th row	FL
5th row	MI

Common Values

Value	Count	Frequency (%)
TX	40393	7.3%
NY	35918	6.5%
PA	34326	6.2%
CA	24135	4.3%
OH	20147	3.6%
MI	19671	3.5%
IL	18960	3.4%
FL	18104	3.3%
AL	17532	3.2%
MO	16501	3.0%
Other values (40)	310032	55.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
tx	40393	7.3%
ny	35918	6.5%
pa	34326	6.2%
ca	24135	4.3%
oh	20147	3.6%
mi	19671	3.5%
il	18960	3.4%
fl	18104	3.3%
al	17532	3.2%
mo	16501	3.0%
Other values (40)	310032	55.8%

Most occurring characters

Value	Count	Frequency (%)
A	152804	13.7%
N	121925	11.0%
M	94062	8.5%
I	78554	7.1%
T	65783	5.9%
L	63584	5.7%
O	61724	5.6%
C	60224	5.4%
Y	56878	5.1%
X	40393	3.6%
Other values (14)	315507	28.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1111438	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	152804	13.7%
N	121925	11.0%
M	94062	8.5%
I	78554	7.1%
T	65783	5.9%
L	63584	5.7%
O	61724	5.6%
C	60224	5.4%
Y	56878	5.1%
X	40393	3.6%
Other values (14)	315507	28.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1111438	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	152804	13.7%
N	121925	11.0%
M	94062	8.5%
I	78554	7.1%
T	65783	5.9%
L	63584	5.7%
O	61724	5.6%
C	60224	5.4%
Y	56878	5.1%
X	40393	3.6%
Other values (14)	315507	28.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1111438	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	152804	13.7%
N	121925	11.0%
M	94062	8.5%
I	78554	7.1%
T	65783	5.9%
L	63584	5.7%
O	61724	5.6%
C	60224	5.4%
Y	56878	5.1%
X	40393	3.6%
Other values (14)	315507	28.4%

zip
Real number (ℝ)

High correlation

Distinct	912
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	48842.628

Minimum	1257
Maximum	99921
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	1257
5-th percentile	7439
Q1	26292
median	48174
Q3	72011
95-th percentile	94569
Maximum	99921
Range	98664
Interquartile range (IQR)	45719

Descriptive statistics

Standard deviation	26855.283
Coefficient of variation (CV)	0.54983289
Kurtosis	-1.0951283
Mean	48842.628
Median Absolute Deviation (MAD)	23058
Skewness	0.077246009
Sum	2.7142776 × 10¹⁰
Variance	7.2120624 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
82514	1589	0.3%
48088	1518	0.3%
34112	1495	0.3%
16114	1474	0.3%
73754	1470	0.3%
29438	1466	0.3%
46346	1462	0.3%
60958	1458	0.3%
40077	1428	0.3%
72165	1426	0.3%
Other values (902)	540933	97.3%

Value	Count	Frequency (%)
1257	900	0.2%
1330	435	0.1%
1535	219	< 0.1%
1545	444	0.1%
1612	219	< 0.1%
1843	1055	0.2%
1844	861	0.2%
2180	219	< 0.1%
2630	834	0.2%
2908	195	< 0.1%

Value	Count	Frequency (%)
99921	14	< 0.1%
99783	635	0.1%
99746	194	< 0.1%
99323	1079	0.2%
99160	1332	0.2%
99113	416	0.1%
99033	1188	0.2%
98836	216	< 0.1%
98665	230	< 0.1%
98304	426	0.1%

lat
Real number (ℝ)

High correlation

Distinct	910
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	38.543253

Minimum	20.0271
Maximum	65.6899
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	20.0271
5-th percentile	29.8826
Q1	34.6689
median	39.3716
Q3	41.8948
95-th percentile	45.8433
Maximum	65.6899
Range	45.6628
Interquartile range (IQR)	7.2259

Descriptive statistics

Standard deviation	5.0613362
Coefficient of variation (CV)	0.13131575
Kurtosis	0.739401
Mean	38.543253
Median Absolute Deviation (MAD)	3.3472
Skewness	-0.20603764
Sum	21419218
Variance	25.617124
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
43.0048	1589	0.3%
42.5164	1518	0.3%
26.1184	1495	0.3%
41.3851	1474	0.3%
36.385	1470	0.3%
32.5486	1466	0.3%
41.4802	1462	0.3%
41.0646	1458	0.3%
38.4921	1428	0.3%
35.5762	1426	0.3%
Other values (900)	540933	97.3%

Value	Count	Frequency (%)
20.0271	659	0.1%
20.0827	431	0.1%
24.6557	1071	0.2%
26.1184	1495	0.3%
26.3304	199	< 0.1%
26.3771	214	< 0.1%
26.4215	1324	0.2%
26.4722	1126	0.2%
26.529	653	0.1%
26.6939	440	0.1%

Value	Count	Frequency (%)
65.6899	194	< 0.1%
64.7556	635	0.1%
55.4732	14	< 0.1%
48.8878	1332	0.2%
48.8856	843	0.2%
48.8328	667	0.1%
48.6669	422	0.1%
48.6031	1403	0.3%
48.4786	878	0.2%
48.34	1293	0.2%

long
Real number (ℝ)

High correlation

Distinct	910
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-90.231325

Minimum	-165.6723
Maximum	-67.9503
Zeros	0
Zeros (%)	0.0%
Negative	555719
Negative (%)	100.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	-165.6723
5-th percentile	-119.0825
Q1	-96.798
median	-87.4769
Q3	-80.1752
95-th percentile	-73.5365
Maximum	-67.9503
Range	97.722
Interquartile range (IQR)	16.6228

Descriptive statistics

Standard deviation	13.72178
Coefficient of variation (CV)	-0.15207335
Kurtosis	1.7942606
Mean	-90.231325
Median Absolute Deviation (MAD)	8.1276
Skewness	-1.1394157
Sum	-50143262
Variance	188.28724
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-108.8964	1589	0.3%
-82.9832	1518	0.3%
-81.7361	1495	0.3%
-80.1752	1474	0.3%
-98.0727	1470	0.3%
-80.307	1466	0.3%
-86.6919	1462	0.3%
-87.5917	1458	0.3%
-85.4524	1428	0.3%
-91.4539	1426	0.3%
Other values (900)	540933	97.3%

Value	Count	Frequency (%)
-165.6723	635	0.1%
-156.292	194	< 0.1%
-155.488	431	0.1%
-155.3697	659	0.1%
-133.1171	14	< 0.1%
-124.4409	424	0.1%
-124.2174	648	0.1%
-124.1587	434	0.1%
-124.1437	672	0.1%
-123.9743	886	0.2%

Value	Count	Frequency (%)
-67.9503	842	0.2%
-68.5565	453	0.1%
-69.2675	224	< 0.1%
-69.4828	881	0.2%
-69.9576	200	< 0.1%
-69.9656	1267	0.2%
-70.239	419	0.1%
-70.3001	834	0.2%
-70.3457	669	0.1%
-70.6993	641	0.1%

city_pop
Real number (ℝ)

Distinct	835
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	88221.888

Minimum	23
Maximum	2906700
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	23
5-th percentile	139
Q1	741
median	2408
Q3	19685
95-th percentile	525713
Maximum	2906700
Range	2906677
Interquartile range (IQR)	18944

Descriptive statistics

Standard deviation	300390.89
Coefficient of variation (CV)	3.4049474
Kurtosis	37.470475
Mean	88221.888
Median Absolute Deviation (MAD)	2161
Skewness	5.5834146
Sum	4.9026579 × 10¹⁰
Variance	9.0234688 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
606	2553	0.5%
1312922	2222	0.4%
1595797	2182	0.4%
241	2045	0.4%
1766	1982	0.4%
2135	1909	0.3%
198	1783	0.3%
1126	1783	0.3%
910148	1765	0.3%
302	1706	0.3%
Other values (825)	535789	96.4%

Value	Count	Frequency (%)
23	866	0.2%
37	456	0.1%
43	886	0.2%
46	1346	0.2%
47	223	< 0.1%
49	418	0.1%
51	454	0.1%
52	222	< 0.1%
53	1050	0.2%
60	427	0.1%

Value	Count	Frequency (%)
2906700	1697	0.3%
2504700	896	0.2%
2383912	216	< 0.1%
1595797	2182	0.4%
1577385	1117	0.2%
1526206	1596	0.3%
1382480	857	0.2%
1312922	2222	0.4%
1263321	1512	0.3%
1241364	1069	0.2%

job
Text

Distinct	478
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

Length

Max length	59
Median length	38
Mean length	20.244753
Min length	3

Characters and Unicode

Total characters	11250394
Distinct characters	53
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Mechanical engineer
2nd row	Sales professional, IT
3rd row	Librarian, public
4th row	Set designer
5th row	Furniture designer

Value	Count	Frequency (%)
engineer	56292	4.6%
officer	47287	3.8%
manager	26713	2.2%
scientist	23862	1.9%
designer	22421	1.8%
surveyor	21226	1.7%
teacher	16739	1.4%
psychologist	14256	1.2%
research	12672	1.0%
editor	12233	1.0%
Other values (448)	981271	79.5%

Most occurring characters

Value	Count	Frequency (%)
e	1200919	10.7%
i	1021383	9.1%
r	942240	8.4%
a	779472	6.9%
t	765550	6.8%
n	756706	6.7%
	679253	6.0%
o	641539	5.7%
s	619943	5.5%
c	567501	5.0%
Other values (43)	3275888	29.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	11250394	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	1200919	10.7%
i	1021383	9.1%
r	942240	8.4%
a	779472	6.9%
t	765550	6.8%
n	756706	6.7%
	679253	6.0%
o	641539	5.7%
s	619943	5.5%
c	567501	5.0%
Other values (43)	3275888	29.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	11250394	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	1200919	10.7%
i	1021383	9.1%
r	942240	8.4%
a	779472	6.9%
t	765550	6.8%
n	756706	6.7%
	679253	6.0%
o	641539	5.7%
s	619943	5.5%
c	567501	5.0%
Other values (43)	3275888	29.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	11250394	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	1200919	10.7%
i	1021383	9.1%
r	942240	8.4%
a	779472	6.9%
t	765550	6.8%
n	756706	6.7%
	679253	6.0%
o	641539	5.7%
s	619943	5.5%
c	567501	5.0%
Other values (43)	3275888	29.1%

dob
Date

Distinct	910
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

Minimum	1924-10-30 00:00:00
Maximum	2005-01-29 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

trans_num
Text

Unique

Distinct	555719
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	17783008
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	555719 ?
Unique (%)	100.0%

Sample

1st row	2da90c7d74bd46a0caf3777415b3ebd3
2nd row	324cc204407e99f51b0d6ca0055005e7
3rd row	c81755dbbbea9d5c77f094348a7579be
4th row	2159175b9efe66dc301f149d3d5abf8c
5th row	57ff021bd3f328f8738bb535c302a31b

Value	Count	Frequency (%)
8be473af4f05fc6146ea55ace73e7ca2	1	< 0.1%
1765bb45b3aa3224b4cdcb6e7a96cee3	1	< 0.1%
2da90c7d74bd46a0caf3777415b3ebd3	1	< 0.1%
324cc204407e99f51b0d6ca0055005e7	1	< 0.1%
c81755dbbbea9d5c77f094348a7579be	1	< 0.1%
2159175b9efe66dc301f149d3d5abf8c	1	< 0.1%
57ff021bd3f328f8738bb535c302a31b	1	< 0.1%
c65a812107218b3b5a73e508b0af6633	1	< 0.1%
e614e054201302dd73f32a3aec38bf0e	1	< 0.1%
8b4b2ea4f0a03359f2f8fa4f418b769c	1	< 0.1%
Other values (555709)	555709	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
4	1113020	6.3%
b	1112778	6.3%
1	1112541	6.3%
7	1112515	6.3%
3	1112419	6.3%
9	1112182	6.3%
8	1111916	6.3%
6	1111791	6.3%
c	1111381	6.2%
0	1111306	6.2%
Other values (6)	6661159	37.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	17783008	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
4	1113020	6.3%
b	1112778	6.3%
1	1112541	6.3%
7	1112515	6.3%
3	1112419	6.3%
9	1112182	6.3%
8	1111916	6.3%
6	1111791	6.3%
c	1111381	6.2%
0	1111306	6.2%
Other values (6)	6661159	37.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	17783008	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
4	1113020	6.3%
b	1112778	6.3%
1	1112541	6.3%
7	1112515	6.3%
3	1112419	6.3%
9	1112182	6.3%
8	1111916	6.3%
6	1111791	6.3%
c	1111381	6.2%
0	1111306	6.2%
Other values (6)	6661159	37.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	17783008	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
4	1113020	6.3%
b	1112778	6.3%
1	1112541	6.3%
7	1112515	6.3%
3	1112419	6.3%
9	1112182	6.3%
8	1111916	6.3%
6	1111791	6.3%
c	1111381	6.2%
0	1111306	6.2%
Other values (6)	6661159	37.5%

unix_time
Real number (ℝ)

High correlation

Distinct	544760
Distinct (%)	98.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.3806789 × 10⁹

Minimum	1.3718169 × 10⁹
Maximum	1.3885344 × 10⁹
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	1.3718169 × 10⁹
5-th percentile	1.3725953 × 10⁹
Q1	1.3760286 × 10⁹
median	1.380762 × 10⁹
Q3	1.385867 × 10⁹
95-th percentile	1.3880236 × 10⁹
Maximum	1.3885344 × 10⁹
Range	16717509
Interquartile range (IQR)	9838356.5

Descriptive statistics

Standard deviation	5201104.1
Coefficient of variation (CV)	0.0037670629
Kurtosis	-1.3677361
Mean	1.3806789 × 10⁹
Median Absolute Deviation (MAD)	5003435
Skewness	-0.077405381
Sum	7.6726948 × 10¹⁴
Variance	2.7051484 × 10¹³
Monotonicity	Increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1387312599	4	< 0.1%
1386957227	4	< 0.1%
1381001869	4	< 0.1%
1387468942	4	< 0.1%
1379588620	3	< 0.1%
1374450545	3	< 0.1%
1387049212	3	< 0.1%
1388208001	3	< 0.1%
1375597240	3	< 0.1%
1375597343	3	< 0.1%
Other values (544750)	555685	> 99.9%

Value	Count	Frequency (%)
1371816865	1	< 0.1%
1371816873	1	< 0.1%
1371816893	1	< 0.1%
1371816915	1	< 0.1%
1371816917	1	< 0.1%
1371816937	1	< 0.1%
1371816944	1	< 0.1%
1371816950	1	< 0.1%
1371816970	1	< 0.1%
1371816971	1	< 0.1%

Value	Count	Frequency (%)
1388534374	1	< 0.1%
1388534364	1	< 0.1%
1388534355	1	< 0.1%
1388534349	1	< 0.1%
1388534347	1	< 0.1%
1388534314	1	< 0.1%
1388534284	1	< 0.1%
1388534276	1	< 0.1%
1388534270	1	< 0.1%
1388534238	1	< 0.1%

merch_lat
Real number (ℝ)

High correlation

Distinct	546490
Distinct (%)	98.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	38.542798

Minimum	19.027422
Maximum	66.679297
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	19.027422
5-th percentile	29.759168
Q1	34.755302
median	39.376593
Q3	41.954163
95-th percentile	45.99952
Maximum	66.679297
Range	47.651875
Interquartile range (IQR)	7.1988615

Descriptive statistics

Standard deviation	5.0958293
Coefficient of variation (CV)	0.13221223
Kurtosis	0.72289788
Mean	38.542798
Median Absolute Deviation (MAD)	3.372633
Skewness	-0.20262611
Sum	21418965
Variance	25.967476
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
39.779565	4	< 0.1%
40.952544	4	< 0.1%
43.091015	3	< 0.1%
33.825714	3	< 0.1%
39.97087	3	< 0.1%
39.661288	3	< 0.1%
41.960596	3	< 0.1%
40.025401	3	< 0.1%
39.593391	3	< 0.1%
40.751975	3	< 0.1%
Other values (546480)	555687	> 99.9%

Value	Count	Frequency (%)
19.027422	1	< 0.1%
19.027849	1	< 0.1%
19.032689	1	< 0.1%
19.038107	1	< 0.1%
19.039532	1	< 0.1%
19.039862	1	< 0.1%
19.04232	1	< 0.1%
19.044747	1	< 0.1%
19.045199	1	< 0.1%
19.046113	1	< 0.1%

Value	Count	Frequency (%)
66.679297	1	< 0.1%
66.674714	1	< 0.1%
66.67154	1	< 0.1%
66.669356	1	< 0.1%
66.668167	1	< 0.1%
66.660454	1	< 0.1%
66.650388	1	< 0.1%
66.646753	1	< 0.1%
66.646051	1	< 0.1%
66.644397	1	< 0.1%

merch_long
Real number (ℝ)

High correlation

Distinct	551770
Distinct (%)	99.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-90.23138

Minimum	-166.67157
Maximum	-66.952026
Zeros	0
Zeros (%)	0.0%
Negative	555719
Negative (%)	100.0%
Memory size	4.2 MiB

Quantile statistics

Minimum	-166.67157
5-th percentile	-119.25804
Q1	-96.905129
median	-87.445204
Q3	-80.264637
95-th percentile	-73.387755
Maximum	-66.952026
Range	99.719549
Interquartile range (IQR)	16.640492

Descriptive statistics

Standard deviation	13.733071
Coefficient of variation (CV)	-0.15219839
Kurtosis	1.7905728
Mean	-90.23138
Median Absolute Deviation (MAD)	8.212831
Skewness	-1.1368095
Sum	-50143293
Variance	188.59723
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-87.009534	3	< 0.1%
-78.096003	3	< 0.1%
-74.300398	3	< 0.1%
-97.483643	3	< 0.1%
-83.536152	3	< 0.1%
-82.268845	3	< 0.1%
-86.365442	3	< 0.1%
-87.256118	3	< 0.1%
-77.244271	3	< 0.1%
-82.357941	3	< 0.1%
Other values (551760)	555689	> 99.9%

Value	Count	Frequency (%)
-166.671575	1	< 0.1%
-166.670685	1	< 0.1%
-166.670006	1	< 0.1%
-166.66991	1	< 0.1%
-166.669812	1	< 0.1%
-166.658797	1	< 0.1%
-166.653605	1	< 0.1%
-166.647052	1	< 0.1%
-166.646643	1	< 0.1%
-166.646507	1	< 0.1%

Value	Count	Frequency (%)
-66.952026	1	< 0.1%
-66.952352	1	< 0.1%
-66.955602	1	< 0.1%
-66.957364	1	< 0.1%
-66.959498	1	< 0.1%
-66.960745	1	< 0.1%
-66.970525	1	< 0.1%
-66.973527	1	< 0.1%
-66.978745	1	< 0.1%
-66.980959	1	< 0.1%

is_fraud
Categorical

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	4.2 MiB

0	553574
1	2145

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	555719
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	553574	99.6%
1	2145	0.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	553574	99.6%
1	2145	0.4%

Most occurring characters

Value	Count	Frequency (%)
0	553574	99.6%
1	2145	0.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	555719	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	553574	99.6%
1	2145	0.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	555719	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	553574	99.6%
1	2145	0.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	555719	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	553574	99.6%
1	2145	0.4%

Interactions

Correlations

	Unnamed: 0	amt	category	cc_num	city_pop	gender	is_fraud	lat	long	merch_lat	merch_long	state	unix_time	zip
Unnamed: 0	1.000	-0.001	0.006	0.001	-0.001	0.000	0.023	-0.000	-0.002	0.000	-0.002	0.000	1.000	0.001
amt	-0.001	1.000	0.021	-0.001	-0.024	0.003	0.000	0.014	-0.001	0.014	-0.001	0.004	-0.001	0.001
category	0.006	0.021	1.000	0.007	0.014	0.055	0.058	0.011	0.009	0.011	0.009	0.019	0.004	0.010
cc_num	0.001	-0.001	0.007	1.000	0.051	0.053	0.004	-0.001	-0.013	-0.002	-0.013	0.238	0.001	0.013
city_pop	-0.001	-0.024	0.014	0.051	1.000	0.090	0.008	-0.261	0.088	-0.260	0.087	0.315	-0.001	-0.042
gender	0.000	0.003	0.055	0.053	0.090	1.000	0.000	0.124	0.091	0.112	0.083	0.255	0.001	0.115
is_fraud	0.023	0.000	0.058	0.004	0.008	0.000	1.000	0.081	0.081	0.081	0.081	0.027	0.022	0.009
lat	-0.000	0.014	0.011	-0.001	-0.261	0.124	0.081	1.000	0.105	0.991	0.103	0.797	-0.000	-0.162
long	-0.002	-0.001	0.009	-0.013	0.088	0.091	0.081	0.105	1.000	0.105	0.998	0.864	-0.002	-0.959
merch_lat	0.000	0.014	0.011	-0.002	-0.260	0.112	0.081	0.991	0.105	1.000	0.103	0.772	0.000	-0.162
merch_long	-0.002	-0.001	0.009	-0.013	0.087	0.083	0.081	0.103	0.998	0.103	1.000	0.832	-0.002	-0.957
state	0.000	0.004	0.019	0.238	0.315	0.255	0.027	0.797	0.864	0.772	0.832	1.000	0.000	0.963
unix_time	1.000	-0.001	0.004	0.001	-0.001	0.001	0.022	-0.000	-0.002	0.000	-0.002	0.000	1.000	0.001
zip	0.001	0.001	0.010	0.013	-0.042	0.115	0.009	-0.162	-0.959	-0.162	-0.957	0.963	0.001	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

	Unnamed: 0	trans_date_trans_time	cc_num	merchant	category	amt	first	last	gender	street	city	state	zip	lat	long	city_pop	job	dob	trans_num	unix_time	merch_lat	merch_long
0	0	2020-06-21 12:14:25	2291163933867244	fraud_Kirlin and Sons	personal_care	2.86	Jeff	Elliott	M	351 Darlene Green	Columbia	SC	29209	33.9659	-80.9355	333497	Mechanical engineer	1968-03-19	2da90c7d74bd46a0caf3777415b3ebd3	1371816865	33.986391	-81.200714
1	1	2020-06-21 12:14:33	3573030041201292	fraud_Sporer-Keebler	personal_care	29.84	Joanne	Williams	F	3638 Marsh Union	Altonah	UT	84002	40.3207	-110.4360	302	Sales professional, IT	1990-01-17	324cc204407e99f51b0d6ca0055005e7	1371816873	39.450498	-109.960431
2	2	2020-06-21 12:14:53	3598215285024754	fraud_Swaniawski, Nitzsche and Welch	health_fitness	41.28	Ashley	Lopez	F	9333 Valentine Point	Bellmore	NY	11710	40.6729	-73.5365	34496	Librarian, public	1970-10-21	c81755dbbbea9d5c77f094348a7579be	1371816893	40.495810	-74.196111
3	3	2020-06-21 12:15:15	3591919803438423	fraud_Haley Group	misc_pos	60.05	Brian	Williams	M	32941 Krystal Mill Apt. 552	Titusville	FL	32780	28.5697	-80.8191	54767	Set designer	1987-07-25	2159175b9efe66dc301f149d3d5abf8c	1371816915	28.812398	-80.883061
4	4	2020-06-21 12:15:17	3526826139003047	fraud_Johnston-Casper	travel	3.19	Nathan	Massey	M	5783 Evan Roads Apt. 465	Falmouth	MI	49632	44.2529	-85.0170	1126	Furniture designer	1955-07-06	57ff021bd3f328f8738bb535c302a31b	1371816917	44.959148	-85.884734
5	5	2020-06-21 12:15:37	30407675418785	fraud_Daugherty LLC	kids_pets	19.55	Danielle	Evans	F	76752 David Lodge Apt. 064	Breesport	NY	14816	42.1939	-76.7361	520	Psychotherapist	1991-10-13	798db04aaceb4febd084f1a7c404da93	1371816937	41.747157	-77.584197
6	6	2020-06-21 12:15:44	213180742685905	fraud_Romaguera Ltd	health_fitness	133.93	Kayla	Sutton	F	010 Weaver Land	Carlotta	CA	95528	40.5070	-123.9743	1139	Therapist, occupational	1951-01-15	17003d7ce534440eadb10c4750e020e5	1371816944	41.499458	-124.888729
7	7	2020-06-21 12:15:50	3589289942931264	fraud_Reichel LLC	personal_care	10.37	Paula	Estrada	F	350 Stacy Glens	Spencer	SD	57374	43.7557	-97.5936	343	Development worker, international aid	1972-03-05	8be473af4f05fc6146ea55ace73e7ca2	1371816950	44.495498	-97.728453
8	8	2020-06-21 12:16:10	3596357274378601	fraud_Goyette, Howell and Collier	shopping_pos	4.37	David	Everett	M	4138 David Fall	Morrisdale	PA	16858	41.0001	-78.2357	3688	Advice worker	1973-05-27	71a1da150d1ce510193d7622e08e784e	1371816970	41.546067	-78.120238
9	9	2020-06-21 12:16:11	3546897637165774	fraud_Kilback Group	food_dining	66.54	Kayla	Obrien	F	7921 Robert Port Suite 343	Prairie Hill	TX	76678	31.6591	-96.8094	263	Barrister	1956-05-30	a7915132c7c4240996ba03a47f81e3bd	1371816971	31.782919	-96.366185

	Unnamed: 0	trans_date_trans_time	cc_num	merchant	category	amt	first	last	gender	street	city	state	zip	lat	long	city_pop	job	dob	trans_num	unix_time	merch_lat	merch_long
555709	555709	2020-12-31 23:57:18	30344654314976	fraud_Larkin, Stracke and Greenfelder	entertainment	46.71	Christine	Johnson	F	8011 Chapman Tunnel Apt. 568	Blairsden-Graeagle	CA	96103	39.8127	-120.6405	1725	Chartered legal executive (England and Wales)	1967-05-27	a7105564935ea3977dc61ff9ced3bf5e	1388534238	38.963543	-120.457121
555710	555710	2020-12-31 23:57:50	3524574586339330	fraud_Heathcote, Yost and Kertzmann	shopping_net	29.56	Ashley	Cabrera	F	94225 Smith Springs Apt. 617	Vero Beach	FL	32960	27.6330	-80.4031	105638	Librarian, public	1986-05-07	9fc9f6f9be3182d519a61a119cf97199	1388534270	27.593881	-80.855092
555711	555711	2020-12-31 23:57:56	341546199006537	fraud_Schmidt-Larkin	home	12.68	Mark	Brown	M	8580 Moore Cove	Wales	AK	99783	64.7556	-165.6723	145	Administrator, education	1939-11-09	a8310343c189e4a5b6316050d2d6b014	1388534276	65.623593	-165.186033
555712	555712	2020-12-31 23:58:04	501802953619	fraud_Pouros, Walker and Spencer	kids_pets	13.02	Robert	Flores	M	3277 Fields Meadows Apt. 790	Greenview	CA	96037	41.5403	-122.9366	308	Call centre manager	1958-09-20	bd7071fd5c9510a5594ee196368ac80e	1388534284	41.973127	-123.553032
555713	555713	2020-12-31 23:58:34	3523843138706408	fraud_Prosacco, Kreiger and Kovacek	home	17.00	Grace	Williams	F	28812 Charles Mill Apt. 628	Plantersville	AL	36758	32.6176	-86.9475	1412	Drilling engineer	1970-11-20	6d04313bfe4b661b8ca2b6a499a320fe	1388534314	32.164145	-87.539669
555714	555714	2020-12-31 23:59:07	30560609640617	fraud_Reilly and Sons	health_fitness	43.77	Michael	Olson	M	558 Michael Estates	Luray	MO	63453	40.4931	-91.8912	519	Town planner	1966-02-13	9b1f753c79894c9f4b71f04581835ada	1388534347	39.946837	-91.333331
555715	555715	2020-12-31 23:59:09	3556613125071656	fraud_Hoppe-Parisian	kids_pets	111.84	Jose	Vasquez	M	572 Davis Mountains	Lake Jackson	TX	77566	29.0393	-95.4401	28739	Futures trader	1999-12-27	2090647dac2c89a1d86c514c427f5b91	1388534349	29.661049	-96.186633
555716	555716	2020-12-31 23:59:15	6011724471098086	fraud_Rau-Robel	kids_pets	86.88	Ann	Lawson	F	144 Evans Islands Apt. 683	Burbank	WA	99323	46.1966	-118.9017	3684	Musician	1981-11-29	6c5b7c8add471975aa0fec023b2e8408	1388534355	46.658340	-119.715054
555717	555717	2020-12-31 23:59:24	4079773899158	fraud_Breitenberg LLC	travel	7.99	Eric	Preston	M	7020 Doyle Stream Apt. 951	Mesa	ID	83643	44.6255	-116.4493	129	Cartographer	1965-12-15	14392d723bb7737606b2700ac791b7aa	1388534364	44.470525	-117.080888
555718	555718	2020-12-31 23:59:34	4170689372027579	fraud_Dare-Marvin	entertainment	38.13	Samuel	Frey	M	830 Myers Plaza Apt. 384	Edmond	OK	73034	35.6665	-97.4798	116001	Media buyer	1993-05-10	1765bb45b3aa3224b4cdcb6e7a96cee3	1388534374	36.210097	-97.036372

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters